Reduce database size?

Hello,

I have a question about reducing the size of a DOORS database.
During the last 2 years, the size of the archive of the DOORS database increased by about 300%, while the content added to the database was surely below 50%.
I could not find something about this in the user guides.
Is there a way of "cleaning" the database?
I am currently using DOORS 8.1

Kind regards,
Axel Werner
Axel1 - Tue May 18 09:09:52 EDT 2010

Re: Reduce database size?
mcnairk - Tue May 18 09:21:08 EDT 2010

Try:
  • Purging deleted objects/modules
  • Baselining

Ken.

Re: Reduce database size?
kbmurphy - Tue May 18 11:41:35 EDT 2010

mcnairk - Tue May 18 09:21:08 EDT 2010
Try:

  • Purging deleted objects/modules
  • Baselining

Ken.

Purging should work, but baselining will only make the database larger. Baselining modules improves module performance, not database size.

Re: Reduce database size?
Axel1 - Wed May 19 10:44:59 EDT 2010

mcnairk - Tue May 18 09:21:08 EDT 2010
Try:

  • Purging deleted objects/modules
  • Baselining

Ken.

Thanks,
purging delete-marked objects reduced the archive size in the order of some percent. Unfortunately it did not solve the problem.

Regards,
Axel

Re: Reduce database size?
kbmurphy - Thu May 20 16:24:35 EDT 2010

Axel1 - Wed May 19 10:44:59 EDT 2010
Thanks,
purging delete-marked objects reduced the archive size in the order of some percent. Unfortunately it did not solve the problem.

Regards,
Axel

Do you have Administrator access to DOORS? Perhaps there are projects/folders that are hidden from your account.

Though I don't know the specifics of how to do this, I'm sure you could list all folders within your DOORS folder today, then do it tomorrow and compare file sizes of each file. There are probably some UNIX commands that will compare this for you, or maybe you could use a tool like subversion.

Either way, once you monitor where the growth is, you can then start to figure out why this is happening.

Re: Reduce database size?
llandale - Fri May 21 11:13:07 EDT 2010

History will make the database larger, even if the size of the data remains unchanged. Baselining will make it larger. Databases grow in size as they are used, that's the way it is.

  • Louie

Re: Reduce database size?
satyendramarina - Sun Dec 08 03:35:30 EST 2013

llandale - Fri May 21 11:13:07 EDT 2010
History will make the database larger, even if the size of the data remains unchanged. Baselining will make it larger. Databases grow in size as they are used, that's the way it is.

  • Louie

Is your database contains some tables, pictures which are causing an increase in database size?

 

please check and try to reduce no of tables and pictures and then check again the database size